Tabela LPersonConsent

Definicja tabeli LPersonConsent

Name

LPersonConsent

Code

LPersonConsent

Comment

 


Lista kolumn tabeli LPersonConsent

Name

Code

LPersonConsentID

LPersonConsentID

PersonID

PersonID

ConsentID

ConsentID

Accepted

Accepted

StartDT

StartDT

Comments

Comments

CaretakerPersonID

CaretakerPersonID

Active

Active


Kolumna LPersonConsentID tabeli LPersonConsent

Definicja kolumny LPersonConsentID tabeli LPersonConsent

Name

LPersonConsentID

Code

LPersonConsentID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

id udzielonej zgody/sprzeciwu


Kolumna PersonID tabeli LPersonConsent

Definicja kolumny PersonID tabeli LPersonConsent

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

osoba


Kolumna ConsentID tabeli LPersonConsent

Definicja kolumny ConsentID tabeli LPersonConsent

Name

ConsentID

Code

ConsentID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

zgoda


Kolumna Accepted tabeli LPersonConsent

Definicja kolumny Accepted tabeli LPersonConsent

Name

Accepted

Code

Accepted

Data Type

NUMBER(3)

Mandatory

Yes

Comment

udzielenie zgody, sprzeciwu


Kolumna StartDT tabeli LPersonConsent

Definicja kolumny StartDT tabeli LPersonConsent

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

data udzielonej zgody, sprzeciwu


Kolumna Comments tabeli LPersonConsent

Definicja kolumny Comments tabeli LPersonConsent

Name

Comments

Code

Comments

Data Type

VARCHAR2(100)

Mandatory

No

Comment

komentarz do zgody, sprzeciwu


Kolumna CaretakerPersonID tabeli LPersonConsent

Definicja kolumny CaretakerPersonID tabeli LPersonConsent

Name

CaretakerPersonID

Code

CaretakerPersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

id opiekuna FK Person:PersonID


Kolumna Active tabeli LPersonConsent

Definicja kolumny Active tabeli LPersonConsent

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

czy wpis jest aktualny


Lista kluczy tabeli LPersonConsent

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LPersonConsent

Definicja klucza Identifier_1 tabeli LPersonConsent

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment